SAP Application specific database tables

Area and Tech Name and Description

Purchasing
EKKO - PO Header
EKPO - PO Item
�� EBAN - Purchase requisition
�� EKBE� - History per Purchase doc.
�� EKKN - Account Assignment in Purchasing Document
�� EBKN - Purchase Requisition Account Assignment

Accounting
BKPF - Accounting Document Header
�� BSEG - Accounting Document Segment
�� CSKS - Cost Center Master Data
�� PRPS - WBS master data
�� AUFK - Order master data

�� CEPC - Profit Center master data
�� RBSELBEST - PO associated with aparked invoice

Line items (Rep: RPUDRIG0)
COVP �� - CO Object: Line Items �(See FM HRGPBS_DRILL_READ_COVP)
COOI�� - Commitments Management: Line Items

PPDHD - Transfer to Accounting: Document Header
�� PPDIT�� - �Transfer to Accounting: Lines in HR IDOCs
�� (See FM HRGPBS_DRILL_SELECT_POST_LINE)

Order data (Network) - IW32
AUFK - Order master data
AFKO - Order header data
AFPO - Order item data

AFVC - Operation within an order
AFVV - quantities/dates/values in the operation

EKKN - Find purchase document(EBELN,EBLP) linked to order(AUFNR)
EBKN - Purchase Requisition Account Assignment

Invoice data
EKKO - PO Header
�� RSEG - Incoming invoice (Invoice doc, PO doc)
�� RBKP - Invoice receipt

Project plan/WBS
PROJ - Project data
�� PRPS - WBS
�� PRHI - WBS breakdown within project��

Sales
VBAK - Header
VBAP - Item
VBPA - Sales Document Partner

Shipment
VTTK - Shipment Header
VTTP - Shipment Item

Delivery
LIKP - Delivery Header
LIPS - Delivery item

Vendor
LFA1 - Vendor Master
LFB1 - Vendor Master (Company Code)

Customer
KNA1 - Customer Master
KNB1 - Customer Master (Company Code)

Material
MARA - Material data
MARC - Material Plant Details

HR
PNP - Get Pernr (Personnel data)
PCH - Get Objec

TEM
TEM table structure

SAP tables list and database views available in the data dictionary
SAP Application specific database tables
SAP HR database tables
SELECT from COOI table
SELECT from COVP table

SAP Application specific database tables

Related Articles